package com.qike.duola.domain;

import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;

public class DuolaTransOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DuolaTransOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andAddUidIsNull() {
            addCriterion("add_uid is null");
            return (Criteria) this;
        }

        public Criteria andAddUidIsNotNull() {
            addCriterion("add_uid is not null");
            return (Criteria) this;
        }

        public Criteria andAddUidEqualTo(Long value) {
            addCriterion("add_uid =", value, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidNotEqualTo(Long value) {
            addCriterion("add_uid <>", value, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidGreaterThan(Long value) {
            addCriterion("add_uid >", value, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidGreaterThanOrEqualTo(Long value) {
            addCriterion("add_uid >=", value, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidLessThan(Long value) {
            addCriterion("add_uid <", value, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidLessThanOrEqualTo(Long value) {
            addCriterion("add_uid <=", value, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidIn(List<Long> values) {
            addCriterion("add_uid in", values, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidNotIn(List<Long> values) {
            addCriterion("add_uid not in", values, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidBetween(Long value1, Long value2) {
            addCriterion("add_uid between", value1, value2, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddUidNotBetween(Long value1, Long value2) {
            addCriterion("add_uid not between", value1, value2, "addUid");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNull() {
            addCriterion("add_time is null");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNotNull() {
            addCriterion("add_time is not null");
            return (Criteria) this;
        }

        public Criteria andAddTimeEqualTo(LocalDateTime value) {
            addCriterion("add_time =", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotEqualTo(LocalDateTime value) {
            addCriterion("add_time <>", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThan(LocalDateTime value) {
            addCriterion("add_time >", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("add_time >=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThan(LocalDateTime value) {
            addCriterion("add_time <", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("add_time <=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeIn(List<LocalDateTime> values) {
            addCriterion("add_time in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotIn(List<LocalDateTime> values) {
            addCriterion("add_time not in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("add_time between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("add_time not between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("order_status is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("order_status is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(Integer value) {
            addCriterion("order_status =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(Integer value) {
            addCriterion("order_status <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(Integer value) {
            addCriterion("order_status >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_status >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(Integer value) {
            addCriterion("order_status <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(Integer value) {
            addCriterion("order_status <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<Integer> values) {
            addCriterion("order_status in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<Integer> values) {
            addCriterion("order_status not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(Integer value1, Integer value2) {
            addCriterion("order_status between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("order_status not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andPlanIdIsNull() {
            addCriterion("plan_id is null");
            return (Criteria) this;
        }

        public Criteria andPlanIdIsNotNull() {
            addCriterion("plan_id is not null");
            return (Criteria) this;
        }

        public Criteria andPlanIdEqualTo(Integer value) {
            addCriterion("plan_id =", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdNotEqualTo(Integer value) {
            addCriterion("plan_id <>", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdGreaterThan(Integer value) {
            addCriterion("plan_id >", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("plan_id >=", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdLessThan(Integer value) {
            addCriterion("plan_id <", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdLessThanOrEqualTo(Integer value) {
            addCriterion("plan_id <=", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdIn(List<Integer> values) {
            addCriterion("plan_id in", values, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdNotIn(List<Integer> values) {
            addCriterion("plan_id not in", values, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdBetween(Integer value1, Integer value2) {
            addCriterion("plan_id between", value1, value2, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdNotBetween(Integer value1, Integer value2) {
            addCriterion("plan_id not between", value1, value2, "planId");
            return (Criteria) this;
        }

        public Criteria andCarIdIsNull() {
            addCriterion("car_id is null");
            return (Criteria) this;
        }

        public Criteria andCarIdIsNotNull() {
            addCriterion("car_id is not null");
            return (Criteria) this;
        }

        public Criteria andCarIdEqualTo(Integer value) {
            addCriterion("car_id =", value, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdNotEqualTo(Integer value) {
            addCriterion("car_id <>", value, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdGreaterThan(Integer value) {
            addCriterion("car_id >", value, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("car_id >=", value, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdLessThan(Integer value) {
            addCriterion("car_id <", value, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdLessThanOrEqualTo(Integer value) {
            addCriterion("car_id <=", value, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdIn(List<Integer> values) {
            addCriterion("car_id in", values, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdNotIn(List<Integer> values) {
            addCriterion("car_id not in", values, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdBetween(Integer value1, Integer value2) {
            addCriterion("car_id between", value1, value2, "carId");
            return (Criteria) this;
        }

        public Criteria andCarIdNotBetween(Integer value1, Integer value2) {
            addCriterion("car_id not between", value1, value2, "carId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdIsNull() {
            addCriterion("formula_id is null");
            return (Criteria) this;
        }

        public Criteria andFormulaIdIsNotNull() {
            addCriterion("formula_id is not null");
            return (Criteria) this;
        }

        public Criteria andFormulaIdEqualTo(Integer value) {
            addCriterion("formula_id =", value, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdNotEqualTo(Integer value) {
            addCriterion("formula_id <>", value, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdGreaterThan(Integer value) {
            addCriterion("formula_id >", value, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("formula_id >=", value, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdLessThan(Integer value) {
            addCriterion("formula_id <", value, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdLessThanOrEqualTo(Integer value) {
            addCriterion("formula_id <=", value, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdIn(List<Integer> values) {
            addCriterion("formula_id in", values, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdNotIn(List<Integer> values) {
            addCriterion("formula_id not in", values, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdBetween(Integer value1, Integer value2) {
            addCriterion("formula_id between", value1, value2, "formulaId");
            return (Criteria) this;
        }

        public Criteria andFormulaIdNotBetween(Integer value1, Integer value2) {
            addCriterion("formula_id not between", value1, value2, "formulaId");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeIsNull() {
            addCriterion("total_volume is null");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeIsNotNull() {
            addCriterion("total_volume is not null");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeEqualTo(Double value) {
            addCriterion("total_volume =", value, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeNotEqualTo(Double value) {
            addCriterion("total_volume <>", value, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeGreaterThan(Double value) {
            addCriterion("total_volume >", value, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeGreaterThanOrEqualTo(Double value) {
            addCriterion("total_volume >=", value, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeLessThan(Double value) {
            addCriterion("total_volume <", value, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeLessThanOrEqualTo(Double value) {
            addCriterion("total_volume <=", value, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeIn(List<Double> values) {
            addCriterion("total_volume in", values, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeNotIn(List<Double> values) {
            addCriterion("total_volume not in", values, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeBetween(Double value1, Double value2) {
            addCriterion("total_volume between", value1, value2, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andTotalVolumeNotBetween(Double value1, Double value2) {
            addCriterion("total_volume not between", value1, value2, "totalVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeIsNull() {
            addCriterion("sign_volume is null");
            return (Criteria) this;
        }

        public Criteria andSignVolumeIsNotNull() {
            addCriterion("sign_volume is not null");
            return (Criteria) this;
        }

        public Criteria andSignVolumeEqualTo(Double value) {
            addCriterion("sign_volume =", value, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeNotEqualTo(Double value) {
            addCriterion("sign_volume <>", value, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeGreaterThan(Double value) {
            addCriterion("sign_volume >", value, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeGreaterThanOrEqualTo(Double value) {
            addCriterion("sign_volume >=", value, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeLessThan(Double value) {
            addCriterion("sign_volume <", value, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeLessThanOrEqualTo(Double value) {
            addCriterion("sign_volume <=", value, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeIn(List<Double> values) {
            addCriterion("sign_volume in", values, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeNotIn(List<Double> values) {
            addCriterion("sign_volume not in", values, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeBetween(Double value1, Double value2) {
            addCriterion("sign_volume between", value1, value2, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSignVolumeNotBetween(Double value1, Double value2) {
            addCriterion("sign_volume not between", value1, value2, "signVolume");
            return (Criteria) this;
        }

        public Criteria andSendTypeIsNull() {
            addCriterion("send_type is null");
            return (Criteria) this;
        }

        public Criteria andSendTypeIsNotNull() {
            addCriterion("send_type is not null");
            return (Criteria) this;
        }

        public Criteria andSendTypeEqualTo(Integer value) {
            addCriterion("send_type =", value, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeNotEqualTo(Integer value) {
            addCriterion("send_type <>", value, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeGreaterThan(Integer value) {
            addCriterion("send_type >", value, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("send_type >=", value, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeLessThan(Integer value) {
            addCriterion("send_type <", value, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeLessThanOrEqualTo(Integer value) {
            addCriterion("send_type <=", value, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeIn(List<Integer> values) {
            addCriterion("send_type in", values, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeNotIn(List<Integer> values) {
            addCriterion("send_type not in", values, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeBetween(Integer value1, Integer value2) {
            addCriterion("send_type between", value1, value2, "sendType");
            return (Criteria) this;
        }

        public Criteria andSendTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("send_type not between", value1, value2, "sendType");
            return (Criteria) this;
        }

        public Criteria andLoadTimeIsNull() {
            addCriterion("load_time is null");
            return (Criteria) this;
        }

        public Criteria andLoadTimeIsNotNull() {
            addCriterion("load_time is not null");
            return (Criteria) this;
        }

        public Criteria andLoadTimeEqualTo(LocalDateTime value) {
            addCriterion("load_time =", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeNotEqualTo(LocalDateTime value) {
            addCriterion("load_time <>", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeGreaterThan(LocalDateTime value) {
            addCriterion("load_time >", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("load_time >=", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeLessThan(LocalDateTime value) {
            addCriterion("load_time <", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("load_time <=", value, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeIn(List<LocalDateTime> values) {
            addCriterion("load_time in", values, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeNotIn(List<LocalDateTime> values) {
            addCriterion("load_time not in", values, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("load_time between", value1, value2, "loadTime");
            return (Criteria) this;
        }

        public Criteria andLoadTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("load_time not between", value1, value2, "loadTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeIsNull() {
            addCriterion("arrival_site_time is null");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeIsNotNull() {
            addCriterion("arrival_site_time is not null");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeEqualTo(LocalDateTime value) {
            addCriterion("arrival_site_time =", value, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeNotEqualTo(LocalDateTime value) {
            addCriterion("arrival_site_time <>", value, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeGreaterThan(LocalDateTime value) {
            addCriterion("arrival_site_time >", value, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("arrival_site_time >=", value, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeLessThan(LocalDateTime value) {
            addCriterion("arrival_site_time <", value, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("arrival_site_time <=", value, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeIn(List<LocalDateTime> values) {
            addCriterion("arrival_site_time in", values, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeNotIn(List<LocalDateTime> values) {
            addCriterion("arrival_site_time not in", values, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("arrival_site_time between", value1, value2, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andArrivalSiteTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("arrival_site_time not between", value1, value2, "arrivalSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeIsNull() {
            addCriterion("leave_site_time is null");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeIsNotNull() {
            addCriterion("leave_site_time is not null");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeEqualTo(LocalDateTime value) {
            addCriterion("leave_site_time =", value, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeNotEqualTo(LocalDateTime value) {
            addCriterion("leave_site_time <>", value, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeGreaterThan(LocalDateTime value) {
            addCriterion("leave_site_time >", value, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("leave_site_time >=", value, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeLessThan(LocalDateTime value) {
            addCriterion("leave_site_time <", value, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("leave_site_time <=", value, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeIn(List<LocalDateTime> values) {
            addCriterion("leave_site_time in", values, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeNotIn(List<LocalDateTime> values) {
            addCriterion("leave_site_time not in", values, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("leave_site_time between", value1, value2, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveSiteTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("leave_site_time not between", value1, value2, "leaveSiteTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeIsNull() {
            addCriterion("leave_mix_time is null");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeIsNotNull() {
            addCriterion("leave_mix_time is not null");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeEqualTo(LocalDateTime value) {
            addCriterion("leave_mix_time =", value, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeNotEqualTo(LocalDateTime value) {
            addCriterion("leave_mix_time <>", value, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeGreaterThan(LocalDateTime value) {
            addCriterion("leave_mix_time >", value, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("leave_mix_time >=", value, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeLessThan(LocalDateTime value) {
            addCriterion("leave_mix_time <", value, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("leave_mix_time <=", value, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeIn(List<LocalDateTime> values) {
            addCriterion("leave_mix_time in", values, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeNotIn(List<LocalDateTime> values) {
            addCriterion("leave_mix_time not in", values, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("leave_mix_time between", value1, value2, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andLeaveMixTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("leave_mix_time not between", value1, value2, "leaveMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeIsNull() {
            addCriterion("return_mix_time is null");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeIsNotNull() {
            addCriterion("return_mix_time is not null");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeEqualTo(LocalDateTime value) {
            addCriterion("return_mix_time =", value, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeNotEqualTo(LocalDateTime value) {
            addCriterion("return_mix_time <>", value, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeGreaterThan(LocalDateTime value) {
            addCriterion("return_mix_time >", value, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("return_mix_time >=", value, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeLessThan(LocalDateTime value) {
            addCriterion("return_mix_time <", value, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("return_mix_time <=", value, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeIn(List<LocalDateTime> values) {
            addCriterion("return_mix_time in", values, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeNotIn(List<LocalDateTime> values) {
            addCriterion("return_mix_time not in", values, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("return_mix_time between", value1, value2, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andReturnMixTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("return_mix_time not between", value1, value2, "returnMixTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("start_time is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("start_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(LocalDateTime value) {
            addCriterion("start_time =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(LocalDateTime value) {
            addCriterion("start_time <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(LocalDateTime value) {
            addCriterion("start_time >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("start_time >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(LocalDateTime value) {
            addCriterion("start_time <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("start_time <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<LocalDateTime> values) {
            addCriterion("start_time in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<LocalDateTime> values) {
            addCriterion("start_time not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("start_time between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("start_time not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNull() {
            addCriterion("finish_time is null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNotNull() {
            addCriterion("finish_time is not null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeEqualTo(LocalDateTime value) {
            addCriterion("finish_time =", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotEqualTo(LocalDateTime value) {
            addCriterion("finish_time <>", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThan(LocalDateTime value) {
            addCriterion("finish_time >", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("finish_time >=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThan(LocalDateTime value) {
            addCriterion("finish_time <", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("finish_time <=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIn(List<LocalDateTime> values) {
            addCriterion("finish_time in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotIn(List<LocalDateTime> values) {
            addCriterion("finish_time not in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("finish_time between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("finish_time not between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNull() {
            addCriterion("goods_id is null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNotNull() {
            addCriterion("goods_id is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualTo(Integer value) {
            addCriterion("goods_id =", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualTo(Integer value) {
            addCriterion("goods_id <>", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThan(Integer value) {
            addCriterion("goods_id >", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("goods_id >=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThan(Integer value) {
            addCriterion("goods_id <", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("goods_id <=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIn(List<Integer> values) {
            addCriterion("goods_id in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotIn(List<Integer> values) {
            addCriterion("goods_id not in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("goods_id between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("goods_id not between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andLineIdIsNull() {
            addCriterion("line_id is null");
            return (Criteria) this;
        }

        public Criteria andLineIdIsNotNull() {
            addCriterion("line_id is not null");
            return (Criteria) this;
        }

        public Criteria andLineIdEqualTo(Integer value) {
            addCriterion("line_id =", value, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdNotEqualTo(Integer value) {
            addCriterion("line_id <>", value, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdGreaterThan(Integer value) {
            addCriterion("line_id >", value, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("line_id >=", value, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdLessThan(Integer value) {
            addCriterion("line_id <", value, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdLessThanOrEqualTo(Integer value) {
            addCriterion("line_id <=", value, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdIn(List<Integer> values) {
            addCriterion("line_id in", values, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdNotIn(List<Integer> values) {
            addCriterion("line_id not in", values, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdBetween(Integer value1, Integer value2) {
            addCriterion("line_id between", value1, value2, "lineId");
            return (Criteria) this;
        }

        public Criteria andLineIdNotBetween(Integer value1, Integer value2) {
            addCriterion("line_id not between", value1, value2, "lineId");
            return (Criteria) this;
        }

        public Criteria andCarNoIsNull() {
            addCriterion("car_no is null");
            return (Criteria) this;
        }

        public Criteria andCarNoIsNotNull() {
            addCriterion("car_no is not null");
            return (Criteria) this;
        }

        public Criteria andCarNoEqualTo(String value) {
            addCriterion("car_no =", value, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoNotEqualTo(String value) {
            addCriterion("car_no <>", value, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoGreaterThan(String value) {
            addCriterion("car_no >", value, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoGreaterThanOrEqualTo(String value) {
            addCriterion("car_no >=", value, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoLessThan(String value) {
            addCriterion("car_no <", value, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoLessThanOrEqualTo(String value) {
            addCriterion("car_no <=", value, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoLike(String value) {
            addCriterion("car_no like", "%"+value+"%", "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoNotLike(String value) {
            addCriterion("car_no not like", value, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoIn(List<String> values) {
            addCriterion("car_no in", values, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoNotIn(List<String> values) {
            addCriterion("car_no not in", values, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoBetween(String value1, String value2) {
            addCriterion("car_no between", value1, value2, "carNo");
            return (Criteria) this;
        }

        public Criteria andCarNoNotBetween(String value1, String value2) {
            addCriterion("car_no not between", value1, value2, "carNo");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(LocalDateTime value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(LocalDateTime value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(LocalDateTime value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(LocalDateTime value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<LocalDateTime> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<LocalDateTime> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeIsNull() {
            addCriterion("waste_volume is null");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeIsNotNull() {
            addCriterion("waste_volume is not null");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeEqualTo(Double value) {
            addCriterion("waste_volume =", value, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeNotEqualTo(Double value) {
            addCriterion("waste_volume <>", value, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeGreaterThan(Double value) {
            addCriterion("waste_volume >", value, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeGreaterThanOrEqualTo(Double value) {
            addCriterion("waste_volume >=", value, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeLessThan(Double value) {
            addCriterion("waste_volume <", value, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeLessThanOrEqualTo(Double value) {
            addCriterion("waste_volume <=", value, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeIn(List<Double> values) {
            addCriterion("waste_volume in", values, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeNotIn(List<Double> values) {
            addCriterion("waste_volume not in", values, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeBetween(Double value1, Double value2) {
            addCriterion("waste_volume between", value1, value2, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andWasteVolumeNotBetween(Double value1, Double value2) {
            addCriterion("waste_volume not between", value1, value2, "wasteVolume");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNull() {
            addCriterion("project_id is null");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNotNull() {
            addCriterion("project_id is not null");
            return (Criteria) this;
        }

        public Criteria andProjectIdEqualTo(Integer value) {
            addCriterion("project_id =", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotEqualTo(Integer value) {
            addCriterion("project_id <>", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThan(Integer value) {
            addCriterion("project_id >", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("project_id >=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThan(Integer value) {
            addCriterion("project_id <", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThanOrEqualTo(Integer value) {
            addCriterion("project_id <=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdIn(List<Integer> values) {
            addCriterion("project_id in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotIn(List<Integer> values) {
            addCriterion("project_id not in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdBetween(Integer value1, Integer value2) {
            addCriterion("project_id between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotBetween(Integer value1, Integer value2) {
            addCriterion("project_id not between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andDistanceIsNull() {
            addCriterion("distance is null");
            return (Criteria) this;
        }

        public Criteria andDistanceIsNotNull() {
            addCriterion("distance is not null");
            return (Criteria) this;
        }

        public Criteria andDistanceEqualTo(Double value) {
            addCriterion("distance =", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotEqualTo(Double value) {
            addCriterion("distance <>", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceGreaterThan(Double value) {
            addCriterion("distance >", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceGreaterThanOrEqualTo(Double value) {
            addCriterion("distance >=", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceLessThan(Double value) {
            addCriterion("distance <", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceLessThanOrEqualTo(Double value) {
            addCriterion("distance <=", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceIn(List<Double> values) {
            addCriterion("distance in", values, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotIn(List<Double> values) {
            addCriterion("distance not in", values, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceBetween(Double value1, Double value2) {
            addCriterion("distance between", value1, value2, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotBetween(Double value1, Double value2) {
            addCriterion("distance not between", value1, value2, "distance");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}